| date | total_post | google_searchVolume | amazon_searchVolume | walmart_searchVolume | client_unit_price | competitor_unit_price | no additives/preservatives | salmon | client_lbs_value | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2016-07-23 00:00:00 | 113.000000 | 1700.000000 | 0.000000 | 0.000000 | 9.424585 | 6.762622 | 0 | 1 | 4786439.000000 |
| 1 | 2018-09-29 00:00:00 | 2649.000000 | 12052.000000 | 532.000000 | 0.000000 | 10.936036 | 5.727254 | 0 | 1 | 5526476.000000 |
| 2 | 2019-03-30 00:00:00 | 1781.000000 | 39684.000000 | 6144.000000 | 1092.000000 | 5.063071 | 7.386886 | 0 | 0 | 4279166.562448 |
| 3 | 2018-04-28 00:00:00 | 259.000000 | 3159.000000 | 94.000000 | 0.000000 | 10.833823 | 5.675104 | 0 | 1 | 4905987.327206 |
| 4 | 2018-03-31 00:00:00 | 360.000000 | 4323.000000 | 0.000000 | 0.000000 | 10.632209 | 5.555296 | 0 | 1 | 5114674.000000 |
| date | total_post | google_searchVolume | amazon_searchVolume | walmart_searchVolume | client_unit_price | competitor_unit_price | no additives/preservatives | salmon | client_lbs_value | |
|---|---|---|---|---|---|---|---|---|---|---|
| 289 | 2017-05-27 00:00:00 | 500.000000 | 7713.000000 | 0.000000 | 0.000000 | 10.468299 | 5.999333 | 0 | 1 | 5127492.171894 |
| 290 | 2018-01-27 00:00:00 | 12434.000000 | 3542.000000 | 178.000000 | 0.000000 | 10.801484 | 5.687655 | 0 | 1 | 5060087.000000 |
| 291 | 2016-11-26 00:00:00 | 2378.000000 | 40544.000000 | 0.000000 | 0.000000 | 4.323914 | 7.987339 | 0 | 0 | 3639712.866197 |
| 292 | 2018-05-26 00:00:00 | 3283.000000 | 38589.000000 | 11767.000000 | 1139.000000 | 4.790466 | 7.714266 | 0 | 0 | 4441815.968357 |
| 293 | 2017-12-30 00:00:00 | 1141.000000 | 715.000000 | 0.000000 | 0.000000 | 10.757761 | 6.036139 | 0 | 1 | 4918901.000000 |
No missing values in data
No Infinity values
No Missing Values
No duplicate variables
| N | < (mean-3*std) | > (mean+3*std) | < (1stQ - 1.5 * IQR) | > (3rdQ + 1.5 * IQR) | -inf | +inf | |
|---|---|---|---|---|---|---|---|
| Feature | |||||||
| total_post | 294 | 0 | 4 | 0 | 10 | 0 | 0 |
| google_searchVolume | 294 | 0 | 2 | 0 | 1 | 0 | 0 |
| amazon_searchVolume | 294 | 0 | 2 | 0 | 61 | 0 | 0 |
| walmart_searchVolume | 294 | 0 | 7 | 0 | 63 | 0 | 0 |
| no additives/preservatives | 294 | 0 | 22 | 0 | 22 | 0 | 0 |
| Variable Name | Datatype | No of Unique | Samples | Mean | Standard Deviation | Min | 25th percentile | Median | 75th percentile | Max | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | amazon_searchVolume | float64 | 119 | [0.0, 532.0, 6144.0, 94.0, 182.0] | 2000.901823 | 3962.348114 | 0.000000 | 0.000000 | 0.000000 | 538.000000 | 13940.567929 |
| 1 | client_lbs_value | float64 | 294 | [4786439.0, 5526476.0, 4279166.56244782, 4905987.327205882, 5114674.0] | 4569749.489077 | 879145.595723 | 2755973.768759 | 3964491.855828 | 4689711.088934 | 5220519.500000 | 6698859.000000 |
| 2 | client_unit_price | float64 | 294 | [9.424584654694256, 10.936036173700442, 5.063071171920445, 10.833823014014182, 10.632208884707362] | 7.491836 | 3.027214 | 4.210722 | 4.618103 | 6.181990 | 10.801067 | 12.398403 |
| 3 | competitor_unit_price | float64 | 294 | [6.762621611699198, 5.727253718183602, 7.386886320587916, 5.675104423545838, 5.5552959511377695] | 7.186329 | 1.129806 | 5.366339 | 6.171850 | 7.421210 | 7.929547 | 10.426700 |
| 4 | google_searchVolume | float64 | 276 | [1700.0, 12052.0, 39684.0, 3159.0, 4323.0] | 24410.400879 | 21563.575941 | 18.000000 | 3584.000000 | 16910.000000 | 44097.250000 | 90031.929217 |
| 5 | total_post | float64 | 277 | [113.0, 2649.0, 1781.0, 259.0, 360.0] | 1641.479657 | 1331.253377 | 0.000000 | 539.000000 | 1576.500000 | 2175.750000 | 6904.754764 |
| 6 | walmart_searchVolume | float64 | 57 | [0.0, 1092.0, 703.0, 42.0, 1584.0] | 242.045913 | 508.468948 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1814.499790 |
| Variable Name | Datatype | No of Unique | Samples | mean | min | 25% | 50% | 75% | max | Mode | Mode Freq | Mode Freq % | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | no additives/preservatives | uint8 | 2 | [0, 1] | NaT | NaT | NaT | NaT | NaT | NaT | 0.000000 | 272.000000 | 92.517007 |
| 1 | salmon | uint8 | 2 | [1, 0] | NaT | NaT | NaT | NaT | NaT | NaT | 0.000000 | 161.000000 | 54.761905 |
| 2 | date | datetime64[ns] | 184 | [numpy.datetime64('2016-07-23T00:00:00.000000000'), numpy.datetime64('2018-09-29T00:00:00.000000000'), numpy.datetime64('2019-03-30T00:00:00.000000000'), numpy.datetime64('2018-04-28T00:00:00.000000000'), numpy.datetime64('2018-03-31T00:00:00.000000000')] | 2017-12-13 17:42:51.428571392 | 2016-01-09 00:00:00 | 2017-01-08 18:00:00 | 2017-12-26 12:00:00 | 2018-11-15 06:00:00 | 2019-10-05 00:00:00 | nan | nan | nan |
| Variable 1 | Variable 2 | Corr Coef | Abs Corr Coef | |
|---|---|---|---|---|
| 0 | client_lbs_value | competitor_unit_price | -0.807848 | 0.807848 |
| 1 | competitor_unit_price | client_lbs_value | -0.807848 | 0.807848 |
| 2 | client_lbs_value | salmon | 0.805645 | 0.805645 |
| 3 | salmon | client_lbs_value | 0.805645 | 0.805645 |
| 4 | client_lbs_value | client_unit_price | 0.752889 | 0.752889 |
| 5 | client_unit_price | client_lbs_value | 0.752889 | 0.752889 |
| 6 | client_lbs_value | google_searchVolume | -0.466867 | 0.466867 |
| 7 | google_searchVolume | client_lbs_value | -0.466867 | 0.466867 |
| 8 | client_lbs_value | no additives/preservatives | -0.455605 | 0.455605 |
| 9 | no additives/preservatives | client_lbs_value | -0.455605 | 0.455605 |
| 10 | client_lbs_value | walmart_searchVolume | -0.068456 | 0.068456 |
| 11 | walmart_searchVolume | client_lbs_value | -0.068456 | 0.068456 |
| 12 | amazon_searchVolume | client_lbs_value | -0.042987 | 0.042987 |
| 13 | client_lbs_value | amazon_searchVolume | -0.042987 | 0.042987 |
| 14 | client_lbs_value | total_post | -0.029345 | 0.029345 |
| 15 | total_post | client_lbs_value | -0.029345 | 0.029345 |